[dbo].[BAEImisState_CodesLoad]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEImisState_CodesLoad
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@STATE_PROVINCE
varchar(15)
15
SQL Script
create
procedure
[dbo]
.
[BAEImisState_CodesLoad]
@STATE_PROVINCE
as
varchar
(
15
)
AS
SELECT
*
FROM
State_Codes
WHERE
STATE_PROVINCE
=
@STATE_PROVINCE
;
GO
Uses
[dbo].[State_Codes]
dbo